Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	19001
Missing cells	7531
Missing cells (%)	2.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.3 MiB
Average record size in memory	128.0 B

Variable types

Numeric	10
Categorical	5
DateTime	1

Alerts

`name` has a high cardinality: 18780 distinct values	High cardinality
`host_name` has a high cardinality: 6307 distinct values	High cardinality
`neighbourhood` has a high cardinality: 215 distinct values	High cardinality
`id` is highly correlated with `host_id`	High correlation
`host_id` is highly correlated with `id`	High correlation
`number_of_reviews` is highly correlated with `reviews_per_month`	High correlation
`reviews_per_month` is highly correlated with `number_of_reviews`	High correlation
`id` is highly correlated with `host_id`	High correlation
`host_id` is highly correlated with `id`	High correlation
`number_of_reviews` is highly correlated with `reviews_per_month`	High correlation
`reviews_per_month` is highly correlated with `number_of_reviews`	High correlation
`number_of_reviews` is highly correlated with `reviews_per_month`	High correlation
`reviews_per_month` is highly correlated with `number_of_reviews`	High correlation
`id` is highly correlated with `host_id`	High correlation
`host_id` is highly correlated with `id`	High correlation
`neighbourhood_group` is highly correlated with `latitude` and 1 other fields	High correlation
`latitude` is highly correlated with `neighbourhood_group` and 1 other fields	High correlation
`longitude` is highly correlated with `neighbourhood_group` and 1 other fields	High correlation
`room_type` is highly correlated with `price`	High correlation
`price` is highly correlated with `room_type`	High correlation
`number_of_reviews` is highly correlated with `reviews_per_month`	High correlation
`reviews_per_month` is highly correlated with `number_of_reviews`	High correlation
`last_review` has 3758 (19.8%) missing values	Missing
`reviews_per_month` has 3758 (19.8%) missing values	Missing
`minimum_nights` is highly skewed (γ1 = 26.36588078)	Skewed
`name` is uniformly distributed	Uniform
`id` has unique values	Unique
`number_of_reviews` has 3758 (19.8%) zeros	Zeros
`availability_365` has 6970 (36.7%) zeros	Zeros

Reproduction

Analysis started	2022-02-21 16:32:51.910814
Analysis finished	2022-02-21 16:33:13.159022
Duration	21.25 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	19001
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18830405.22

Minimum	2539
Maximum	36485609
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	2539
5-th percentile	1177971
Q1	9355498
median	19387536
Q3	28919516
95-th percentile	35240782
Maximum	36485609
Range	36483070
Interquartile range (IQR)	19564018

Descriptive statistics

Standard deviation	10969857.88
Coefficient of variation (CV)	0.5825609034
Kurtosis	-1.225663309
Mean	18830405.22
Median Absolute Deviation (MAD)	9804926
Skewness	-0.06687371468
Sum	3.577965297 × 10¹¹
Variance	1.203377819 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9138664	1	< 0.1%
17922181	1	< 0.1%
13746962	1	< 0.1%
20917712	1	< 0.1%
26734288	1	< 0.1%
10527546	1	< 0.1%
9518	1	< 0.1%
12188651	1	< 0.1%
28959608	1	< 0.1%
15158194	1	< 0.1%
Other values (18991)	18991	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2539	1	< 0.1%
3831	1	< 0.1%
5022	1	< 0.1%
5121	1	< 0.1%
5203	1	< 0.1%
5238	1	< 0.1%
5803	1	< 0.1%
6090	1	< 0.1%
6848	1	< 0.1%
7750	1	< 0.1%

Value	Count	Frequency (%)
36485609	1	< 0.1%
36485057	1	< 0.1%
36480292	1	< 0.1%
36479723	1	< 0.1%
36478343	1	< 0.1%
36472171	1	< 0.1%
36471896	1	< 0.1%
36468880	1	< 0.1%
36458668	1	< 0.1%
36456829	1	< 0.1%

name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	18780
Distinct (%)	98.9%
Missing	7
Missing (%)	< 0.1%
Memory size	148.6 KiB

Hillside Hotel	7
Brooklyn Apartment	7
Home away from home	6
Private Room	6
New york Multi-unit building	5
Other values (18775)	18963

Length

Max length	179
Median length	36
Mean length	36.75139518
Min length	1

Characters and Unicode

Total characters	72
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18619 ?
Unique (%)	98.0%

Sample

1st row	Private Lg Room 15 min to Manhattan
2nd row	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC
3rd row	Voted #1 Location Quintessential 1BR W Village Apt
4th row	Spacious 1 bedroom apartment 15min from Manhattan
5th row	Big beautiful bedroom in huge Bushwick apartment

Common Values

Value	Count	Frequency (%)
Hillside Hotel	7	< 0.1%
Brooklyn Apartment	7	< 0.1%
Home away from home	6	< 0.1%
Private Room	6	< 0.1%
New york Multi-unit building	5	< 0.1%
Cozy Room	5	< 0.1%
Private room in Manhattan	5	< 0.1%
Private room in Williamsburg	4	< 0.1%
Cozy Private Room	4	< 0.1%
Williamsburg Loft	3	< 0.1%
Other values (18770)	18942	99.7%
(Missing)	7	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
in	6594	5.7%
room	4014	3.5%
	3161	2.7%
bedroom	3016	2.6%
private	2874	2.5%
apartment	2658	2.3%
cozy	2017	1.7%
apt	1765	1.5%
brooklyn	1623	1.4%
studio	1556	1.3%
Other values (6673)	86285	74.7%

Most occurring characters

Value	Count	Frequency (%)
	72	100.0%

Most occurring categories

Value	Count	Frequency (%)
Control	72	100.0%

Most frequent character per category

Control

Value	Count	Frequency (%)
	72	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	72	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	72	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	72	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	72	100.0%

host_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	16241
Distinct (%)	85.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	66394588.99

Minimum	2571
Maximum	274273284
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	2571
5-th percentile	764688
Q1	7728754
median	30487854
Q3	104835356
95-th percentile	239519185
Maximum	274273284
Range	274270713
Interquartile range (IQR)	97106602

Descriptive statistics

Standard deviation	77826632.15
Coefficient of variation (CV)	1.172183356
Kurtosis	0.2898665825
Mean	66394588.99
Median Absolute Deviation (MAD)	27185317
Skewness	1.245958822
Sum	1.261563585 × 10¹²
Variance	6.056984672 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
219517861	117	0.6%
107434423	71	0.4%
30283594	44	0.2%
137358866	36	0.2%
12243051	36	0.2%
61391963	34	0.2%
16098958	33	0.2%
22541573	32	0.2%
26377263	24	0.1%
2856748	22	0.1%
Other values (16231)	18552	97.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2571	1	< 0.1%
2787	3	< 0.1%
3151	1	< 0.1%
3415	1	< 0.1%
3563	1	< 0.1%
3647	2	< 0.1%
4396	1	< 0.1%
4869	1	< 0.1%
5089	1	< 0.1%
6041	1	< 0.1%

Value	Count	Frequency (%)
274273284	1	< 0.1%
274195458	1	< 0.1%
274103383	1	< 0.1%
273870123	1	< 0.1%
273841667	1	< 0.1%
273741577	1	< 0.1%
273656890	1	< 0.1%
273632292	1	< 0.1%
273619304	1	< 0.1%
273613106	1	< 0.1%

host_name
Categorical

HIGH CARDINALITY

Distinct	6307
Distinct (%)	33.2%
Missing	8
Missing (%)	< 0.1%
Memory size	148.6 KiB

Michael	159
David	157
John	130
Sonder (NYC)	117
Alex	98
Other values (6302)	18332

Length

Max length	35
Median length	6
Mean length	6.100931922
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4077 ?
Unique (%)	21.5%

Sample

1st row	Iris
2nd row	Johlex
3rd row	John
4th row	Regan
5th row	Megan

Common Values

Value	Count	Frequency (%)
Michael	159	0.8%
David	157	0.8%
John	130	0.7%
Sonder (NYC)	117	0.6%
Alex	98	0.5%
Daniel	92	0.5%
Sarah	87	0.5%
Maria	86	0.5%
Chris	81	0.4%
Anna	77	0.4%
Other values (6297)	17909	94.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	401	1.9%
and	234	1.1%
michael	175	0.8%
david	169	0.8%
sonder	153	0.7%
john	145	0.7%
nyc	122	0.6%
alex	121	0.6%
laura	117	0.6%
maria	105	0.5%
Other values (5877)	19369	91.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

neighbourhood_group
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	148.6 KiB

Brooklyn	8046
Manhattan	8031
Queens	2331
Bronx	434
Staten Island	159

Length

Max length	13
Median length	8
Mean length	8.150623651
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Queens
2nd row	Manhattan
3rd row	Manhattan
4th row	Queens
5th row	Brooklyn

Common Values

Value	Count	Frequency (%)
Brooklyn	8046	42.3%
Manhattan	8031	42.3%
Queens	2331	12.3%
Bronx	434	2.3%
Staten Island	159	0.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
brooklyn	8046	42.0%
manhattan	8031	41.9%
queens	2331	12.2%
bronx	434	2.3%
staten	159	0.8%
island	159	0.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

neighbourhood
Categorical

HIGH CARDINALITY

Distinct	215
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	148.6 KiB

Williamsburg	1526
Bedford-Stuyvesant	1478
Harlem	1086
Bushwick	978
Upper West Side	734
Other values (210)	13199

Length

Max length	26
Median length	12
Mean length	11.91947792
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	0.1%

Sample

1st row	Sunnyside
2nd row	Hell's Kitchen
3rd row	West Village
4th row	Astoria
5th row	Bushwick

Common Values

Value	Count	Frequency (%)
Williamsburg	1526	8.0%
Bedford-Stuyvesant	1478	7.8%
Harlem	1086	5.7%
Bushwick	978	5.1%
Upper West Side	734	3.9%
East Village	705	3.7%
Hell's Kitchen	693	3.6%
Upper East Side	667	3.5%
Crown Heights	631	3.3%
Midtown	505	2.7%
Other values (205)	9998	52.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
east	2575	8.4%
side	1756	5.7%
harlem	1540	5.0%
williamsburg	1526	5.0%
bedford-stuyvesant	1478	4.8%
heights	1427	4.7%
upper	1401	4.6%
village	1186	3.9%
west	1033	3.4%
bushwick	978	3.2%
Other values (227)	15760	51.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

latitude
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12087
Distinct (%)	63.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.72806312

Minimum	40.50873
Maximum	40.91306
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	40.50873
5-th percentile	40.64456
Q1	40.68882
median	40.72171
Q3	40.76321
95-th percentile	40.82645
Maximum	40.91306
Range	0.40433
Interquartile range (IQR)	0.07439

Descriptive statistics

Standard deviation	0.05538931047
Coefficient of variation (CV)	0.001359978998
Kurtosis	0.05864487992
Mean	40.72806312
Median Absolute Deviation (MAD)	0.03659
Skewness	0.2542518047
Sum	773873.9274
Variance	0.003067975714
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.71813	8	< 0.1%
40.72232	8	< 0.1%
40.68634	8	< 0.1%
40.69414	8	< 0.1%
40.68683	7	< 0.1%
40.72607	7	< 0.1%
40.68084	7	< 0.1%
40.72434	6	< 0.1%
40.76389	6	< 0.1%
40.70741	6	< 0.1%
Other values (12077)	18930	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
40.50873	1	< 0.1%
40.52293	1	< 0.1%
40.53871	1	< 0.1%
40.53939	1	< 0.1%
40.54106	1	< 0.1%
40.54312	1	< 0.1%
40.5455	1	< 0.1%
40.54857	1	< 0.1%
40.54889	1	< 0.1%
40.54901	1	< 0.1%

Value	Count	Frequency (%)
40.91306	1	< 0.1%
40.90527	1	< 0.1%
40.90391	1	< 0.1%
40.90356	1	< 0.1%
40.90329	1	< 0.1%
40.90281	1	< 0.1%
40.9026	1	< 0.1%
40.89981	1	< 0.1%
40.89811	1	< 0.1%
40.89756	1	< 0.1%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	9944
Distinct (%)	52.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-73.95082679

Minimum	-74.23914
Maximum	-73.71795
Zeros	0
Zeros (%)	0.0%
Negative	19001
Negative (%)	100.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	-74.23914
5-th percentile	-74.00369
Q1	-73.98205
median	-73.95463
Q3	-73.93449
95-th percentile	-73.86186
Maximum	-73.71795
Range	0.52119
Interquartile range (IQR)	0.04756

Descriptive statistics

Standard deviation	0.04682498719
Coefficient of variation (CV)	-0.0006331908543
Kurtosis	4.824279693
Mean	-73.95082679
Median Absolute Deviation (MAD)	0.02489
Skewness	1.234020827
Sum	-1405139.66
Variance	0.002192579425
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.94829	9	< 0.1%
-73.95725	9	< 0.1%
-73.95121	9	< 0.1%
-73.95742	9	< 0.1%
-73.95427	9	< 0.1%
-73.98589	9	< 0.1%
-73.95675	8	< 0.1%
-73.9567	8	< 0.1%
-73.95149	8	< 0.1%
-73.98043	8	< 0.1%
Other values (9934)	18915	99.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-74.23914	1	< 0.1%
-74.21238	1	< 0.1%
-74.19626	1	< 0.1%
-74.18259	1	< 0.1%
-74.17628	1	< 0.1%
-74.17388	1	< 0.1%
-74.17117	1	< 0.1%
-74.17065	1	< 0.1%
-74.16966	1	< 0.1%
-74.16634	1	< 0.1%

Value	Count	Frequency (%)
-73.71795	1	< 0.1%
-73.71829	1	< 0.1%
-73.72582	1	< 0.1%
-73.72716	1	< 0.1%
-73.72731	1	< 0.1%
-73.7274	1	< 0.1%
-73.72778	1	< 0.1%
-73.72817	1	< 0.1%
-73.72901	1	< 0.1%
-73.72928	1	< 0.1%

room_type
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	148.6 KiB

Entire home/apt	9522
Private room	9041
Shared room	438

Length

Max length	15
Median length	15
Mean length	13.48034314
Min length	11

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Private room

Common Values

Value	Count	Frequency (%)
Entire home/apt	9522	50.1%
Private room	9041	47.6%
Shared room	438	2.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
entire	9522	25.1%
home/apt	9522	25.1%
room	9479	24.9%
private	9041	23.8%
shared	438	1.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

price
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	321
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.3404558

Minimum	10
Maximum	350
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	10
5-th percentile	40
Q1	66
median	100
Q3	160
95-th percentile	270
Maximum	350
Range	340
Interquartile range (IQR)	94

Descriptive statistics

Standard deviation	71.53034564
Coefficient of variation (CV)	0.5846826807
Kurtosis	0.5028006941
Mean	122.3404558
Median Absolute Deviation (MAD)	45
Skewness	1.027024411
Sum	2324591
Variance	5116.590347
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	856	4.5%
150	821	4.3%
50	636	3.3%
200	590	3.1%
75	570	3.0%
60	555	2.9%
80	531	2.8%
70	482	2.5%
120	471	2.5%
65	471	2.5%
Other values (311)	13018	68.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	6	< 0.1%
11	2	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
15	1	< 0.1%
16	3	< 0.1%
18	1	< 0.1%
19	3	< 0.1%
20	13	0.1%
21	3	< 0.1%

Value	Count	Frequency (%)
350	147	0.8%
349	14	0.1%
348	1	< 0.1%
347	2	< 0.1%
346	1	< 0.1%
345	11	0.1%
344	1	< 0.1%
343	2	< 0.1%
342	1	< 0.1%
341	2	< 0.1%

minimum_nights
Real number (ℝ_≥0)

SKEWED

Distinct	75
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.906899637

Minimum	1
Maximum	1250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	30
Maximum	1250
Range	1249
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	21.45654397
Coefficient of variation (CV)	3.10653768
Kurtosis	1156.455229
Mean	6.906899637
Median Absolute Deviation (MAD)	1
Skewness	26.36588078
Sum	131238
Variance	460.3832792
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	5003	26.3%
2	4619	24.3%
3	3086	16.2%
30	1442	7.6%
4	1253	6.6%
5	1140	6.0%
7	822	4.3%
6	285	1.5%
14	210	1.1%
10	178	0.9%
Other values (65)	963	5.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5003	26.3%
2	4619	24.3%
3	3086	16.2%
4	1253	6.6%
5	1140	6.0%
6	285	1.5%
7	822	4.3%
8	52	0.3%
9	34	0.2%
10	178	0.9%

Value	Count	Frequency (%)
1250	1	< 0.1%
999	2	< 0.1%
480	1	< 0.1%
400	1	< 0.1%
370	1	< 0.1%
365	11	0.1%
364	1	< 0.1%
300	1	< 0.1%
299	1	< 0.1%
240	2	< 0.1%

number_of_reviews
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	321
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.79774749

Minimum	0
Maximum	607
Zeros	3758
Zeros (%)	19.8%
Negative	0
Negative (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	24
95-th percentile	116
Maximum	607
Range	607
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	45.49345456
Coefficient of variation (CV)	1.911670614
Kurtosis	19.56592146
Mean	23.79774749
Median Absolute Deviation (MAD)	6
Skewness	3.706018813
Sum	452181
Variance	2069.654408
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3758	19.8%
1	2022	10.6%
2	1342	7.1%
3	975	5.1%
4	796	4.2%
5	589	3.1%
6	544	2.9%
7	495	2.6%
8	449	2.4%
9	383	2.0%
Other values (311)	7648	40.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3758	19.8%
1	2022	10.6%
2	1342	7.1%
3	975	5.1%
4	796	4.2%
5	589	3.1%
6	544	2.9%
7	495	2.6%
8	449	2.4%
9	383	2.0%

Value	Count	Frequency (%)
607	1	< 0.1%
594	1	< 0.1%
510	1	< 0.1%
488	1	< 0.1%
474	1	< 0.1%
467	1	< 0.1%
466	1	< 0.1%
459	1	< 0.1%
448	1	< 0.1%
441	1	< 0.1%

last_review
Date

MISSING

Distinct	1494
Distinct (%)	9.8%
Missing	3758
Missing (%)	19.8%
Memory size	148.6 KiB

Minimum	2011-05-12 00:00:00
Maximum	2019-07-08 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	789
Distinct (%)	5.2%
Missing	3758
Missing (%)	19.8%
Infinite	0
Infinite (%)	0.0%
Mean	1.380927639

Minimum	0.01
Maximum	27.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.19
median	0.72
Q3	2.01
95-th percentile	4.69
Maximum	27.95
Range	27.94
Interquartile range (IQR)	1.82

Descriptive statistics

Standard deviation	1.689988413
Coefficient of variation (CV)	1.22380664
Kurtosis	11.9516004
Mean	1.380927639
Median Absolute Deviation (MAD)	0.62
Skewness	2.435330583
Sum	21049.48
Variance	2.856060837
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	362	1.9%
1	352	1.9%
0.05	333	1.8%
0.03	323	1.7%
0.04	268	1.4%
0.08	256	1.3%
0.16	244	1.3%
0.09	235	1.2%
0.06	226	1.2%
0.11	217	1.1%
Other values (779)	12427	65.4%
(Missing)	3758	19.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01	17	0.1%
0.02	362	1.9%
0.03	323	1.7%
0.04	268	1.4%
0.05	333	1.8%
0.06	226	1.2%
0.07	168	0.9%
0.08	256	1.3%
0.09	235	1.2%
0.1	191	1.0%

Value	Count	Frequency (%)
27.95	1	< 0.1%
20.94	1	< 0.1%
19.75	1	< 0.1%
17.82	1	< 0.1%
16.22	1	< 0.1%
13.45	1	< 0.1%
13.42	1	< 0.1%
13.24	1	< 0.1%
13.15	1	< 0.1%
12.99	1	< 0.1%

calculated_host_listings_count
Real number (ℝ_≥0)

Distinct	47
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.583811378

Minimum	1
Maximum	327
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	13
Maximum	327
Range	326
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	31.15475023
Coefficient of variation (CV)	4.732023511
Kurtosis	77.21481439
Mean	6.583811378
Median Absolute Deviation (MAD)	0
Skewness	8.461222905
Sum	125099
Variance	970.6184621
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	12627	66.5%
2	2605	13.7%
3	1123	5.9%
4	539	2.8%
5	345	1.8%
6	208	1.1%
7	165	0.9%
8	164	0.9%
327	117	0.6%
9	98	0.5%
Other values (37)	1010	5.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	12627	66.5%
2	2605	13.7%
3	1123	5.9%
4	539	2.8%
5	345	1.8%
6	208	1.1%
7	165	0.9%
8	164	0.9%
9	98	0.5%
10	69	0.4%

Value	Count	Frequency (%)
327	117	0.6%
232	71	0.4%
121	44	0.2%
103	36	0.2%
96	69	0.4%
91	34	0.2%
87	32	0.2%
65	19	0.1%
52	41	0.2%
50	16	0.1%

availability_365
Real number (ℝ_≥0)

ZEROS

Distinct	366
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	109.7253829

Minimum	0
Maximum	365
Zeros	6970
Zeros (%)	36.7%
Negative	0
Negative (%)	0.0%
Memory size	148.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	39
Q3	219
95-th percentile	358
Maximum	365
Range	365
Interquartile range (IQR)	219

Descriptive statistics

Standard deviation	130.5998995
Coefficient of variation (CV)	1.190243279
Kurtosis	-0.9348291358
Mean	109.7253829
Median Absolute Deviation (MAD)	39
Skewness	0.8027018468
Sum	2084892
Variance	17056.33374
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6970	36.7%
365	432	2.3%
364	195	1.0%
1	176	0.9%
5	133	0.7%
3	115	0.6%
2	113	0.6%
179	112	0.6%
89	111	0.6%
6	110	0.6%
Other values (356)	10534	55.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6970	36.7%
1	176	0.9%
2	113	0.6%
3	115	0.6%
4	107	0.6%
5	133	0.7%
6	110	0.6%
7	96	0.5%
8	85	0.4%
9	83	0.4%

Value	Count	Frequency (%)
365	432	2.3%
364	195	1.0%
363	88	0.5%
362	62	0.3%
361	44	0.2%
360	33	0.2%
359	49	0.3%
358	53	0.3%
357	33	0.2%
356	26	0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	9138664	Private Lg Room 15 min to Manhattan	47594947	Iris	Queens	Sunnyside	40.74271	-73.92493	Private room	74	2	6	2019-05-26	0.13	1	5
1	31444015	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC	8523790	Johlex	Manhattan	Hell's Kitchen	40.76682	-73.98878	Entire home/apt	170	3	0	NaT	NaN	1	188
2	8741020	Voted #1 Location Quintessential 1BR W Village Apt	45854238	John	Manhattan	West Village	40.73631	-74.00611	Entire home/apt	245	3	51	2018-09-19	1.12	1	0
3	34602077	Spacious 1 bedroom apartment 15min from Manhattan	261055465	Regan	Queens	Astoria	40.76424	-73.92351	Entire home/apt	125	3	1	2019-05-24	0.65	1	13
4	23203149	Big beautiful bedroom in huge Bushwick apartment	143460	Megan	Brooklyn	Bushwick	40.69839	-73.92044	Private room	65	2	8	2019-06-23	0.52	2	8
5	4402805	LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK	22807362	Jenny	Brooklyn	Prospect-Lefferts Gardens	40.66025	-73.96270	Entire home/apt	120	3	3	2018-08-28	0.05	1	16
6	30070126	✩Prime Renovated 1/1 Apartment in Upper East Side✩	4968673	Sean	Manhattan	Upper East Side	40.76831	-73.95929	Entire home/apt	200	5	2	2019-05-26	0.68	1	71
7	34231172	Fully renovated brick house floor in Brooklyn	59642348	Kevin	Brooklyn	Sunset Park	40.64550	-74.01262	Entire home/apt	95	1	9	2019-07-08	9.00	1	106
8	5856760	Renovated 1BR in exciting, convenient area	29408349	Chad	Manhattan	Chinatown	40.71490	-73.99976	Entire home/apt	179	5	7	2017-04-18	0.14	1	0
9	7929441	Beautiful Loft w/ Waterfront View!	1453898	Anthony	Brooklyn	Williamsburg	40.71268	-73.96676	Private room	105	2	232	2019-06-19	5.00	3	64

Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
18991	5192459	Quiet Room in 4BR UWS Brownstone	10677483	Greg	Manhattan	Upper West Side	40.80173	-73.96625	Private room	70	1	0	NaT	NaN	1	0
18992	1327940	Huge Gorgeous Park View Apartment!	3290436	Hadar	Brooklyn	Flatbush	40.65335	-73.96257	Entire home/apt	120	3	13	2016-08-27	0.28	2	327
18993	23612681	Shared Room 1 Stop from Manhattan on the F Train	55724558	Taylor	Queens	Long Island City	40.76006	-73.94080	Private room	55	4	2	2019-06-01	0.65	5	89
18994	34485745	Midtown Manhattan Stunner - Private room	261632622	Royalton	Manhattan	Theater District	40.75491	-73.98507	Private room	100	1	3	2019-06-16	3.00	9	318
18995	25616250	Stylish, spacious, private 1BR apt in Ditmas Park	125396920	Adam	Brooklyn	Flatbush	40.64314	-73.95705	Entire home/apt	75	3	10	2019-01-03	0.84	1	0
18996	7094539	Tranquil haven in bubbly Brooklyn	2052211	Adriana	Brooklyn	Windsor Terrace	40.65360	-73.97546	Entire home/apt	143	14	2	2016-08-27	0.04	1	10
18997	4424261	Large 1 BR with backyard on UWS	3447311	Sarah	Manhattan	Upper West Side	40.80188	-73.96808	Entire home/apt	200	2	22	2019-05-21	0.50	1	0
18998	4545882	Amazing studio/Loft with a backyard	23569951	Kaveh	Manhattan	Upper East Side	40.78110	-73.94567	Entire home/apt	220	3	28	2019-05-23	0.50	1	293
18999	26518547	U2 comfortable double bed sleeps 2 guests	295128	Carol Gloria	Bronx	Clason Point	40.81225	-73.85502	Private room	80	1	4	2019-07-01	1.48	7	365
19000	33631782	Private Bedroom in Williamsburg Apt!	8569221	Andi	Brooklyn	Williamsburg	40.71829	-73.95819	Private room	109	3	3	2019-04-28	1.07	2	97

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Control

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows